Help With Conditional Formula

P

pt_lily

I need help creating a formula. Here is the criteria:

I have 2 cells (E4 and F4) that might contain a percentage. They might also
both be blank.
I then need a formula calculated off of that percentage.
=G4-(G4*E4)
Where E4 is, I need it to multiply by either E4 or F4 depending on which
cell contains the percentage. Is there a way to do this?

Thank you!!
 
B

Barb Reinhardt

I'm going to assume that either E4 or F4 has a value, but not both.

One way:

=IF(ISBLANK(E4),IF(ISBLANK(F4),NA(),G4-(G4*E4)),G4-G4*F4)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top