IF Function

[Guest]

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??

 

[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

 

[Guest]

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)

 

[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

 

[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