Conditional Formula: If Text, rep as number to sum, else sum numbers.

**etal** · 12-29-2008, 04:49 PM

I can get only so far, then stumped:

3 columns (Hours, Rate, Amount)
"Hours" is a 'List' with data from from another sheet.
Data is named 'Worked'.
'Worked' is all 2 decimal numeric (represents total time worked), except first item called "Live In"

IF 'Hours' is "Live In", I can use:

=IF(A1="Live In", SUM(B1*1))

How can I make it conditional so that if it's not "Live In", then it will SUM(A1*B1)?

SideNote: 'Worked' LIST has total time with minutes expressed as 1/4 of hour (i.e., 1.25 = 1 hour, 15 minutes).

Thanks.

**Ron Coderre** · 12-29-2008, 04:54 PM

Maybe this(?)

Please Login or Register  to view this content.

Does that help?
(if NO...please post a sample workbook to help us understand)

**shg** · 12-29-2008, 05:11 PM

Or maybe =IF(A1="Live In", B1, A1 * B1)

**etal** · 12-29-2008, 05:29 PM

THANK YOU!

(duh!) Nothing like making things more complicated than it should be.
I don't need to calculate the rate if it's the same amount!

Would you also be able to tell me how to keep 'C1' (Amount) blank if there were no entries for 'A1' (Hours) and 'B1' (Rate)?

**etal** · 12-29-2008, 05:36 PM

Okay, tried the following and got what I wanted. The following worked.
THANK YOU SOOO MUCH!

=IF((OR(A1="",B1="")),"",IF(A1="Live In", B1, A1*B1))

**VBA Noob** · 12-29-2008, 05:48 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

VBA Noob