chrispre
asked on
Google Spreadsheet Formula
Looking for some help on creating a formula for Google Spreadsheets.
I have the following cells
A1 B1 C1 D1
Item Cost Savings Cost after savings
Juice $1.99 $0.75 $0.49
Pretzels $3.99 $0.99 $2.01
Plates $2.50 $0.55 $1.50
Cleaner $1.99 $1.00 $0.99
I need a formula that says to only double the value of column C up to $0.99 ($1.98), anything after that is just face value, i.e. $1.00, $1.25, $2.00
Help
I have the following cells
A1 B1 C1 D1
Item Cost Savings Cost after savings
Juice $1.99 $0.75 $0.49
Pretzels $3.99 $0.99 $2.01
Plates $2.50 $0.55 $1.50
Cleaner $1.99 $1.00 $0.99
I need a formula that says to only double the value of column C up to $0.99 ($1.98), anything after that is just face value, i.e. $1.00, $1.25, $2.00
Help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.