Questions & Answers for: nested formulas

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

...formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion? Best way to ...

Identifying Cells which add up to a desired result Hi, I have a spreadsheet as follows Column A 1 17 23 34 54 67 18 23 15 3 I would like a formula which identifies all cells either singly or together ...

then use this one: =IF(OR(A9 >=70, B9 >= 200, C9 = "HIGH"),"High","Low"). You could also do it with nested IFs, but this is cleaner and easier

If/Then Formula I am working on a spreadsheet where I need to use "if/then". However, I need for it read by columns not each row...is this possible? For example "if E=1 then K=X" "if F=1 then L=X" "if

Respected Sir/Madam Kindly write the following placidus formula into the excel sheet: Cyril Gupta wrote: > other houses with that ascendant in view. I need someone who can guide > me in ...

ROM-DOS Fatal Error! Stack Overflow (6E47:000B)! System Halted... I have an agebra fx 2.0 plus and have this error message..what can i do to fix this? The Stack Error message is sent if the ...