IF Function

M

Martyn D

I have two columns headed Quote Value and P/O No respectively.
I want to add a third column that places the value from the quote value
column when I enter the P/O No in the second column; this will enable me to
track sum of quotes vs sum of P/Os received.
Can , and how do, I use the IF Function??
 
S

simpleMod

use the IF function with a conditional using ISBLANK for null fields an
making sure that no spaces were entered using TRIM and LEN functions

msg back if stuck with formula
 
M

mzehr

Hi Martyn
Assuming that your quote value is in Column A, P/O No is in B and your
results are to be in Column C try using the following formula in C2
=if(isblank(B2),"",A2)
 
J

JulieD

Hi Martyn

just checking:
if you have Quote Value in column A
P/O No in column B
when you enter P/O No next to the Quote Value you want the quote value to
appear in column C
if so, then in C2
type
=IF(B2<>"",A2,"")
this says, if there is something in B2, put the value from A2 in cell C2,
otherwise leave it blank.

Hope this helps
Cheers
JulieD
 
F

Frank Stone

hi,
assuming quote = column A and p/o = column B then in
column c put the following:

=if(B2= "", "", A2)

Adjust columns A,B and C to your columns.
Regards
Frank
 
Top