I NEED TO CORRECT THE FOLLOWING FORMULA
If the AH2 is less than 10 apply zeroHTML Code:
if the AH2 is more than 10 and less than (G2/E2) apply AH2
If the Ah2 is more than (G2/E2) apply (G2/E2)
I NEED TO CORRECT THE FOLLOWING FORMULA
If the AH2 is less than 10 apply zeroHTML Code:
if the AH2 is more than 10 and less than (G2/E2) apply AH2
If the Ah2 is more than (G2/E2) apply (G2/E2)
Try it this way:
=IF(AH2<=10,0,IF(AH2>=G2/E2,G2/E2,AH2))
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks