Questions & Answers for: Excel nested formulas Computers & Internet

Nested IF functions in excel I am writing a formula that can calculate a persons payable tax based on different tax brackets. I have so far:=IF(C6>6000,0.15%*(C6-6000),0) where C6 is the persons gross

calculate a bill calculation of electricity bill provided rates for units <=50 is Rs 2, >50n <=100 is Rs 3, >100 n <=300 is RS 4 per unit ,.. find out the bill for 40 units , 88 units , 280 units etc ...

HELP with macro config I would like to type an account number into cell B15 so if B15= (10023) then the other cells must automaticaly display as follows B12=name & G12=po box 1234 G13=city G14=postal ...

Excel formula creation Hi! I would like to create an formula for in and out stock control system. For example: Total Stock minus OUT quantity= Live stocks (10-5=5) I am taking out stocks many times ...

I calculated percentage on excel using a formula but still it shows #value?. what do i have do to fix this? please help. Right Click on cell with mouse and select format cells then select number . If ...

Excel 7 subtraction: say Cell D5 minus E5 - what is formula to enter in F5? =d5-e5 If I understand your question correctly, the formula is simply =d5-e5

can excel automatically count numbered rows and recount if a row is deleted? yes it is all in the formula in the bar download excel user manual (pdf version ) and it will explain how to write the ...

How do you subtract on Excel EXCEL view the operation as a function fX and you enter it like this: =MINUS(H21,H22) This will show up in the cell and on the function bar above the column letters. The ...

Formula in excel 2013 for if statement Hi, trying to create a formula that says if cell A has a date in it then add 3 Days to the cell with the formula, if cell A has "not req" in it show " not req" ...

Formula on adding numbers on excel spread sheet Hello Anton, Please elaborate your query ? Regards, Seb