From your steps posted above (1-3), I would use this...
=IF(OR(E5={"",0}),0,IF(E5<6,450,IF(E5>=6,900,"")))
and format the cell as currency
From your steps posted above (1-3), I would use this...
=IF(OR(E5={"",0}),0,IF(E5<6,450,IF(E5>=6,900,"")))
and format the cell as currency
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks