I need to insert a formula in G19.
I need G19 to be ZERO if either F4 or F5 have value of N. Otherwise, G19 should have the SUM of G4, G5, G11 and G15.
F4 and F5 may have values or Y or N. All G's contain Dollar values.
I have tried this, but it does not work:
=IF((F4=N,OR,F5=N),0,(SUM(G4,G5,G11,G15)))
What am I doing wrong?
=IF(countif(F4:F5,N)>0,,SUM(G4,G5,G11,G15))
=IF ( OR ( F4 = "N", F5 = "N" ) , 0, G4+G5+G11+G15 )
when you say $ values, i assume numbers formatted as $ nd not text with $ in the cell
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
This works. Thank you Wayne.
Last edited by vicstone; 02-24-2020 at 02:02 PM. Reason: Name
This works only is both F4 and F5 are NOriginally Posted by tim201110
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks