Hi
I'm trying to write an IF formula that will apply a second IF if the result is >0. I have produced this (returns inserted to make it clearer what I'm trying to do):
=IF(A1>0, (test)
(=IF(((AD10+AE10)>786),(((AD10+AE10)-786)*0.065),0)) (value if true)
,0) (value if false)
but it doesn't work. Am I trying to do something impossible, or just doing something wrong? The middle IF formula works fine, but not when embedded. Help!
Thanks
Nim
Bookmarks